Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Table "{{timings_817826}}" for active record class "SurveyTimingDynamic" missing

frank.nord
Topic Author
Offline
New Member

More

6 days 9 hours ago #275190 by frank.nord

Table "{{timings_817826}}" for active record class "SurveyTimingDynamic" missing was created by frank.nord

Please help us help you and fill where relevant:
LimeSurvey version: LimeSurvey Community Edition Version 7.2.0+260921
Own server or LimeSurvey Cloud: Own server
Survey theme/template: Fruity ( fruity )
==================
After updating to vesion 7, several surveys are failing with

The table "{{timings_817826}}" for active record class "SurveyTimingDynamic" cannot be found in the database

in

Code:

/LimeSurveyHome/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(2391)

where 817826 is the survey ID.

Code:

   /**
    * Constructor.
    * @param CActiveRecord $model the model instance
    * @throws CDbException if specified table for active record class cannot be found in the database
    */
   public function __construct($model)
   {
       $this->_modelClassName=get_class($model);

       $tableName=$model->tableName();
       if(($table=$model->getDbConnection()->getSchema()->getTable($tableName))===null)
           throw new CDbException(Yii::t('yii','The table "{table}" for active record class "{class}" cannot be found in the database.',
               array('{class}'=>$this->_modelClassName,'{table}'=>$tableName)));
               
       if(($modelPk=$model->primaryKey())!==null || $table->primaryKey===null)
       {
           $table->primaryKey=$modelPk;
           if(is_string($table->primaryKey) && isset($table->columns[$table->primaryKey]))
               $table->columns[$table->primaryKey]->isPrimaryKey=true;
           elseif(is_array($table->primaryKey))
           {
               foreach($table->primaryKey as $name)
               {
                   if(isset($table->columns[$name]))

Stack Trace

Code:

#0+
  /vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(413): [b]CActiveRecordMetaData[/b]->[b]__construct[/b]()#1+
  /vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(79): [b]CActiveRecord[/b]->[b]getMetaData[/b]()#2–
  /application/helpers/expressions/em_manager_helper.php(5252): [b]CActiveRecord[/b]->[b]__construct[/b]()5247             }
5248 
5249             //Insert Row for Timings, if needed
5250             if ($this->surveyOptions['savetimings']) {
5251                 SurveyTimingDynamic::sid($this->sid);
5252                 $oSurveyTimings = new SurveyTimingDynamic();
5253 
5254                 $tdata = [
5255                     'id'            => $srid,
5256                     'interviewtime' => 0
5257                 ];
#3–
 /application/helpers/expressions/em_manager_helper.php(5046): [b]LimeExpressionManager[/b]->[b]_UpdateValuesInDatabase[/b]()5041                     if (!$result['relevant'] || $result['hidden']) {
5042                         // then skip this group
5043                         continue;
5044                     } else {
5045                         // display new group
5046                         $message .= $LEM->_UpdateValuesInDatabase();
5047                         $LEM->runtimeTimings[] = [__METHOD__, (microtime(true) - $now)];
5048                         $LEM->lastMoveResult = [
5049                             'finished'      => false,
5050                             'message'       => $message,
5051                             'gseq'          => $LEM->currentGroupSeq,
#4–
/application/helpers/SurveyRuntimeHelper.php(984): [b]LimeExpressionManager[/b]::[b]NavigateForwards[/b]()979                     $this->aMoveResult = false; // so display welcome page again
980                 }
981             }
982 
983             if ($this->sMove == "movenext") {
984                 $this->aMoveResult = LimeExpressionManager::NavigateForwards();
985             }
986 
987             if (($this->sMove == 'movesubmit')) {
988                 if ($this->sSurveyMode == 'survey') {
989                     $this->aMoveResult = LimeExpressionManager::NavigateForwards();
#5+
/application/helpers/SurveyRuntimeHelper.php(666): [b]SurveyRuntimeHelper[/b]->[b]setMoveResult[/b]()#6+
 /application/helpers/SurveyRuntimeHelper.php(208): [b]SurveyRuntimeHelper[/b]->[b]initMove[/b]()#7+
 /application/controllers/survey/SurveyIndex.php(692): [b]SurveyRuntimeHelper[/b]->[b]run[/b]()#8+
 /application/controllers/survey/SurveyIndex.php(21): [b]SurveyIndex[/b]->[b]action[/b]()#9+
  /vendor/yiisoft/yii/framework/web/actions/CAction.php(76): [b]SurveyIndex[/b]->[b]run[/b]()#10+
  /vendor/yiisoft/yii/framework/web/CController.php(308): [b]CAction[/b]->[b]runWithParams[/b]()#11+
  /vendor/yiisoft/yii/framework/web/CController.php(286): [b]CController[/b]->[b]runAction[/b]()#12+
  /vendor/yiisoft/yii/framework/web/CController.php(265): [b]CController[/b]->[b]runActionWithFilters[/b]()#13+
  /vendor/yiisoft/yii/framework/web/CWebApplication.php(282): [b]CController[/b]->[b]run[/b]()#14+
/vendor/yiisoft/yii/framework/web/CWebApplication.php(141): [b]CWebApplication[/b]->[b]runController[/b]()#15+
/vendor/yiisoft/yii/framework/base/CApplication.php(185): [b]CWebApplication[/b]->[b]processRequest[/b]()#16+
/index.php(161): [b]CApplication[/b]->[b]run[/b]()

Please Log in to join the conversation.